{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Menu","Instructions","Summary Instructions","Data Capture Demand","Data Capture Costs","Primary Baseline Tariff","Strategic Decisions","Revised Primary Baseline Tariff","Test Revised Primary Baseline"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":8,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Menu","index":0,"n_rows":5,"n_cols":10,"rows_kept":5,"cut":false,"hidden":false,"merged":[[2,3,2,5],[3,3,3,5],[4,3,4,5]]}
[]
[]
[null,null,null,"SANITATION"]
[null,null,null,"SubMenu",null,null,null,null,null,{"$f":"[1]Menu!$I$4","v":"SA RANDS"}]
[null,null,null,null,null,null,null,null,null,{"$f":"[1]Menu!$I$5","v":2011}]

{"sheet":"Instructions","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Summary Instructions","index":2,"n_rows":50,"n_cols":6,"rows_kept":50,"cut":false,"hidden":false,"merged":[[2,2,2,7],[11,5,12,7],[7,2,7,7],[18,2,18,7],[33,2,33,7]]}
[]
[]
[null,null,"SANITATION - SUMMARY INSTRUCTIONS"]
[]
[null,null,null,"Capture anticipated and current Consumer information on this screen."]
[]
[]
[null,null,"Any cell with this background colour is a DATA INPUT cell."]
[]
[null,null,"Data Required"]
[null,null,"Consumer  - "]
[null,null,"No of Users - ","The number of consumers using the service (current as well anticipated).",null,"Municipal specific DATA INPUT"]
[null,null,"Current Actual Tariff - ","Tariff charged in the last financial year for each Consumer group."]
[]
[]
[null,null,null,"Capture the costs for the budget vote on this screen"]
[]
[]
[null,null,"Any cell with this background colour is a DATA INPUT cell."]
[]
[]
[null,null,null,"The Primary baseline is calculated and then displayed on this screen."]
[]
[]
[null,null,null,"   TOTAL RING FENCED COSTS       "]
[null,null,"Primary Baseline","  TOTAL NO OF SANITATION USERS"]
[]
[]
[]
[]
[null,null,null,"Input data for Strategic Decisions on this screen.  "]
[null,null,null,"Input data can be in the form of a number or a % change."]
[]
[null,null,"Any cell with this background colour is an optional DATA INPUT cell."]
[]
[]
[null,null,null,"The revised Tariff takes into account input from Strategic Decisions and revises the Tariff accordingly"]
[]
[]
[]
[null,null,null,"This screen compares the Current Actual Tariff and Revenue to the Revised Tariff and Revenue."]
[]
[]
[null,null,"% CHANGE","Use the %Change column to increase or decrease the Revised Tariff.  As you enter the % change the Tariff and Revenue will change to reflect your input."]
[]
[null,null,"Current Actual - Revised","This column displays the difference between Tariffs together with a colour indicator."]
[null,null,"TARIFF"]
[]
[null,null,"PROFIT\\LOSS","This column displays the difference between Revenues together with a colour indicator."]
[null,null,"REVENUE"]

{"sheet":"Data Capture Demand","index":3,"n_rows":51,"n_cols":7,"rows_kept":51,"cut":false,"hidden":false,"merged":[[4,5,4,6],[6,5,6,6],[6,2,6,3],[2,2,2,6],[4,2,4,3]]}
[]
[]
[null,null,{"$f":"Menu!D3&\" - DATA CAPTURE: DEMAND PER MONTH\"","v":"SANITATION - DATA CAPTURE: DEMAND PER MONTH"}]
[]
[null,null,"FUTURE DEMAND",null,null,"HISTORICAL DEMAND"]
[]
[null,null,{"$f":"\"Financial Year:\"&\" \"&Menu!$J$5&\"\\\"&Menu!$J$5+1","v":"Financial Year: 2011\\2012"},null,null,{"$f":"SUM(Menu!$J$5-1)&\"\\\"&SUM(Menu!$J$5)","v":"2010\\2011"}]
[null,null,"CONSUMER","NO OF USERS",null,"NO OF USERS","CURRENT ACTUAL TARIFF per Month"]
[null,null,"DOMESTIC"]
[null,null,"Low Income",1000,null,1000,85]
[null,null,"Middle Income",4550,null,4550,85]
[null,null,"High Income",4650,null,4550,85]
[null,null,"Other",0,null,0,0]
[null,null,"Other",0,null,0,0]
[null,null,"Other",0,null,0,0]
[null,null,"Total No of Sanitation Users",{"$f":"SUM(D10:D15)","v":10200},null,{"$f":"SUM(F10:F15)","v":10100}]
[]
[null,null,"INDUSTRIAL"]
[null,null,"Toilets",1000,null,1000,85]
[null,null,"Urnials",1000,null,1000,85]
[null,null,"Type 3",0,null,0,0]
[null,null,"Type 4",0,null,0,0]
[null,null,"Type 5",0,null,0,0]
[null,null,"Type 6",0,null,0,0]
[null,null,"Type 7",0,null,0,0]
[null,null,"Type 8",0,null,0,0]
[null,null,"Type 9",0,null,0,0]
[null,null,"Total No of Sanitation Users",{"$f":"SUM(D19:D27)","v":2000},null,{"$f":"SUM(F19:F27)","v":2000}]
[]
[null,null,"COMMERCIAL"]
[null,null,"Per Toilet Pan",500,null,400,85]
[null,null,"Per Urinal",500,null,400,0]
[null,null,"Type 3",0,null,0,0]
[null,null,"Type 4",0,null,0,0]
[null,null,"Type 5",0,null,0,0]
[null,null,"Total No of Sanitation Users",{"$f":"SUM(D31:D35)","v":1000},null,{"$f":"SUM(F31:F35)","v":800}]
[]
[null,null,"INSTITUTIONAL"]
[null,null,"Municipal - toilets",250,null,250,60]
[null,null,"Municipal - Urinals",250,null,250,60]
[null,null,"Bona Fide Sports Clubs",0,null,0,0]
[null,null,"Other",0,null,0,0]
[null,null,"Other",0,null,0,0]
[null,null,"Other",0,null,0,0]
[null,null,"Other",0,null,0,0]
[null,null,"Other",0,null,0,0]
[null,null,"Other",0,null,0,0]
[null,null,"Other",0,null,0,0]
[null,null,"Total No of Sanitation Users",{"$f":"SUM(D39:D48)","v":500},null,{"$f":"SUM(F39:F48)","v":500}]
[]
[null,null,"TOTAL NO OF SANITATION USERS",{"$f":"SUM(D16+D28+D36+D49)","v":13700},null,{"$f":"SUM(F16+F28+F36+F49)","v":13400}]

{"sheet":"Data Capture Costs","index":4,"n_rows":96,"n_cols":51,"rows_kept":96,"cut":false,"hidden":false,"merged":[[2,2,2,4],[4,3,4,4]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.01]
[null,null,{"$f":"Menu!D3&\" - DATA CAPTURE: COSTS BY BUDGET VOTE\"","v":"SANITATION - DATA CAPTURE: COSTS BY BUDGET VOTE"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.02]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.08]
[null,null,"COSTS BY BUDGET VOTE",{"$f":"Menu!$J$4","v":"SA RANDS"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.09]
[null,null,"Costs","Detail",{"$f":"\"Year\"&\" \"&Menu!$J$5&\"\\\"&Menu!$J$5+1","v":"Year 2011\\2012"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1]
[null,null,"Bulk Purchases:","Bulk Purchases",2400000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.11]
[null,null,"Employee Related Costs:","Basic Salaries",6000000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.12]
[null,null,"Employee Related Costs:","Social Contributions",900000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.13]
[null,null,"Repairs and Maintenance","Repairs and Maintenance",300000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.14000000000000001]
[null,null,"Other Costs:","General Costs",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.15]
[null,null,"Other Costs:","Collection Commission",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.16]
[null,null,"Other Cost:","Contracted Services",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.17]
[null,null,"Other Costs:","Contributions to Provisions",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.18]
[null,null,"Other Costs:","Debt Impairment",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.19]
[null,null,"Other Costs:","Motor Vehicle Costs",360000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.2]
[null,null,"Depreciation:",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.21]
[null,null,"External Interest:",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.22]
[null,null,"Reserves\\Provisions for Capital Improvements:",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.23]
[null,null,"Other Costs:",null,720000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.24]
[null,null,"Other Costs:",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.25]
[null,null,"Other Costs:",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.26]
[null,null,"Other Costs:",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.27]
[null,null,"Other Costs:",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.28000000000000003]
[null,null,"Other Costs:",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.28999999999999998]
[null,null,"Overhead Costs Re-Allocated (+)",null,1260000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.3]
[null,null,"Overhead Costs Re-Allocated (-)","Less",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.31]
[null,null,"Less Sundry Income ","Less Sundry Income Generated from Indirect Services",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.32]
[null,null,"TOTAL RING FENCED COSTS PER ANNUM",null,{"$f":"SUM(E7:E26)-E27-E28","v":11940000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.33]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.34]
[null,null,"TOTAL RING FENCED COSTS PER MONTH",null,{"$f":"E29/12","v":995000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.36]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.38]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.39]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.41]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.43]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.44]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.46]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.47]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.49]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.51]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.52]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.53]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.54]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.55000000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.56000000000000005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.56999999999999995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.57999999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.59]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.61]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.62]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.63]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.64]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.65]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.66]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.67]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.68]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.69]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.71]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.72]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.73]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.74]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.76]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.77]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.78]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.79]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.81]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.82]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.83]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.84]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.85]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.86]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.87]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.88]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.89]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.91]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.92]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.93]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.94]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.95]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.96]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.97]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.98]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.99]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]

{"sheet":"Primary Baseline Tariff","index":5,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[4,2,4,3],[2,2,2,3]]}
[]
[]
[null,null,"PRIMARY BASELINE TARIFF"]
[]
[null,null,"Below is a basic tariff calculated per baseline unit. "]
[]
[null,null,"DETAIL","TARIFF"]
[null,null,"TOTAL COSTS MONTHLY",{"$f":"'Data Capture Costs'!E31","v":995000}]
[null,null,{"$f":"'Data Capture Demand'!C51","v":"TOTAL NO OF SANITATION USERS"},{"$f":"'Data Capture Demand'!D51","v":13700}]
[null,null,"MONTHLY TARIFF",{"$f":"IF(D8=0,0,D8/D9)","v":72.627737226277375}]

{"sheet":"Strategic Decisions","index":6,"n_rows":22,"n_cols":56,"rows_kept":22,"cut":false,"hidden":false,"merged":[[4,9,6,9],[2,2,2,5],[12,9,14,9],[14,2,14,5]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[]
[null,null,"STRATEGIC DECISIONS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[null,null,"FINANCIAL DECISIONS","AMOUNT","%","% AMT",null,null,null,"REVISED PRIMARY BASELINE TARIFF"]
[null,1,"Do you wish to achieve a Surplus on this service?","YES"]
[null,null,null,"NO"]
[null,null,"Enter Size of the Surplus",0,0,{"$f":"E8%*'Primary Baseline Tariff'!$D$8","v":0},null,null,null,{"$f":"'Revised Primary Baseline Tariff'!D10","v":72.627737226277375}]
[]
[null,2,"Are you willing to make a Deficit on this service?","YES"]
[null,null,null,"NO"]
[null,null,"Enter Size of the Deficit",0,0,{"$f":"-(E12%)*'Primary Baseline Tariff'!$D$8","v":0}]
[null,null,null,null,null,null,null,null,null,"CHANGES TO COSTS"]
[null,null,"AFFORDABILITY DECISIONS","AMOUNT","%","% AMT"]
[null,null,"Most of these decisions are contained in the municipality's  Tariff policy and therefore already form part of the information used to populate the model. However the decisions can at this point be re-visited  and altered as necessary before the tariff  is finalised."]
[null,3,"Do you plan to subsidise the delivery of this service (excluding Free Basic Services)?","YES",null,null,null,null,1,{"$f":"D8+F8","v":0}]
[null,null,null,"NO",null,null,null,null,2,{"$f":"D12+F12","v":0}]
[null,null,"Enter Size of Subsidy",0,0,{"$f":"E18%*'Primary Baseline Tariff'!$D$8","v":0},null,null,3,{"$f":"D18+F18","v":0}]
[]
[null,4,"Do you wish to limit the Size of the Tariff levied on certain type of consumers?","CHANGE TARIFF",null,null,null,null,null,{"$f":"J16-J17+J18","v":0}]
[]
[null,5,"Do you wish to Escalate the Tariff levied on certain type of consumers?","CHANGE TARIFF"]

{"sheet":"Revised Primary Baseline Tariff","index":7,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,2,2,3],[4,2,4,3]]}
[]
[]
[null,null,"REVISED PRIMARY BASELINE TARIFF"]
[]
[null,null,"After Strategic Decisions this is the revised tariff."]
[]
[null,null,"DETAIL","TARIFF"]
[null,null,{"$f":"'Primary Baseline Tariff'!C8","v":"TOTAL COSTS MONTHLY"},{"$f":"'Primary Baseline Tariff'!D8+'Strategic Decisions'!J20","v":995000}]
[null,null,{"$f":"'Primary Baseline Tariff'!C9","v":"TOTAL NO OF SANITATION USERS"},{"$f":"'Primary Baseline Tariff'!D9","v":13700}]
[null,null,{"$f":"'Primary Baseline Tariff'!C10","v":"MONTHLY TARIFF"},{"$f":"IF(D$8=0,0,D8/D$9)","v":72.627737226277375}]

{"sheet":"Test Revised Primary Baseline","index":8,"n_rows":47,"n_cols":15,"rows_kept":47,"cut":false,"hidden":false,"merged":[[6,1,39,1],[2,2,2,14],[4,4,4,5],[4,9,4,11],[4,2,5,2],[4,3,5,3],[4,6,4,7],[45,12,45,13],[46,12,46,13],[44,12,44,13],[44,4,44,5],[43,4,43,6],[44,10,44,11],[43,10,43,13]]}
[]
[]
[null,null,"CURRENT & REVISED TARIFF COMPARISON MONTHLY"]
[]
[null,null,{"$f":"'Data Capture Demand'!C8","v":"CONSUMER"},{"$f":"'Data Capture Demand'!D8&\" (\"&Menu!J5&\")\"","v":"NO OF USERS (2011)"},"CURRENT ACTUAL per month",null,"REVISED TARIFF per month",null,null,"AFFORDABILITY ADJUSTMENT TO  REVISED PRIMARY BASELINE per month",null,null,null,"Current Actual - Revised","PROFIT\\LOSS"]
[null,null,null,null,"TARIFF","REVENUE","TARIFF","REVENUE",null,"% CHANGE","TARIFF","REVENUE",null,"TARIFF","REVENUE"]
[null,null,{"$f":"IF('Data Capture Demand'!C10=\"\",\"\",'Data Capture Demand'!C10)","v":"Low Income"},{"$f":"'Data Capture Demand'!D10","v":1000},{"$f":"'Data Capture Demand'!G10","v":85},{"$f":"SUM(E7*'Data Capture Demand'!F10)","v":85000},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":72.627737226277375},{"$f":"SUM(D7*G7)","v":72627.737226277372},0,0,{"$f":"SUM(G7*J7%)+G7","v":72.627737226277375},{"$f":"D7*K7","v":72627.737226277372},null,{"$f":"K7-E7","v":-12.372262773722625},-12372.262773722628]
[null,null,{"$f":"IF('Data Capture Demand'!C11=\"\",\"\",'Data Capture Demand'!C11)","v":"Middle Income"},{"$f":"'Data Capture Demand'!D11","v":4550},{"$f":"'Data Capture Demand'!G11","v":85},{"$f":"SUM(E8*'Data Capture Demand'!F11)","v":386750},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":72.627737226277375},330456.20437956206,0,0,72.627737226277375,330456.20437956206,null,-12.372262773722625,-56293.795620437944]
[null,null,{"$f":"IF('Data Capture Demand'!C12=\"\",\"\",'Data Capture Demand'!C12)","v":"High Income"},{"$f":"'Data Capture Demand'!D12","v":4650},{"$f":"'Data Capture Demand'!G12","v":85},{"$f":"SUM(E9*'Data Capture Demand'!F12)","v":386750},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":72.627737226277375},337718.97810218978,0,0,72.627737226277375,337718.97810218978,null,-12.372262773722625,-49031.02189781022]
[null,null,{"$f":"IF('Data Capture Demand'!C13=\"\",\"\",'Data Capture Demand'!C13)","v":"Other"},{"$f":"'Data Capture Demand'!D13","v":0},{"$f":"'Data Capture Demand'!G13","v":0},{"$f":"SUM(E10*'Data Capture Demand'!F13)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":72.627737226277375},0,0,0,72.627737226277375,0,null,72.627737226277375,0]
[null,null,{"$f":"IF('Data Capture Demand'!C14=\"\",\"\",'Data Capture Demand'!C14)","v":"Other"},{"$f":"'Data Capture Demand'!D14","v":0},{"$f":"'Data Capture Demand'!G14","v":0},{"$f":"SUM(E11*'Data Capture Demand'!F14)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":72.627737226277375},0,0,0,72.627737226277375,0,null,72.627737226277375,0]
[null,null,{"$f":"IF('Data Capture Demand'!C15=\"\",\"\",'Data Capture Demand'!C15)","v":"Other"},{"$f":"'Data Capture Demand'!D15","v":0},{"$f":"'Data Capture Demand'!G15","v":0},{"$f":"SUM(E12*'Data Capture Demand'!F15)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":72.627737226277375},0,0,0,72.627737226277375,0,null,72.627737226277375,0]
[null,null,{"$f":"'Data Capture Demand'!C9&\" TOTAL\"","v":"DOMESTIC TOTAL"},{"$f":"SUM(D7:D12)","v":10200},null,{"$f":"SUM(F7:F12)","v":858500},null,{"$f":"SUM(H7:H12)","v":740802.91970802913},null,null,null,{"$f":"SUM(L7:L12)","v":740802.91970802913},null,null,{"$f":"SUM(O7:O12)","v":-117697.08029197079}]
[null,null,{"$f":"IF('Data Capture Demand'!C19=\"\",\"\",'Data Capture Demand'!C19)","v":"Toilets"},{"$f":"'Data Capture Demand'!D19","v":1000},{"$f":"'Data Capture Demand'!G19","v":85},{"$f":"SUM(E14*'Data Capture Demand'!F19)","v":85000},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":72.627737226277375},{"$f":"SUM(D14*G14)","v":72627.737226277372},0,0,{"$f":"SUM(G14*J14%)+G14","v":72.627737226277375},{"$f":"D14*K14","v":72627.737226277372},null,{"$f":"K14-E14","v":-12.372262773722625},{"$f":"L14-F14","v":-12372.262773722628}]
[null,null,{"$f":"IF('Data Capture Demand'!C20=\"\",\"\",'Data Capture Demand'!C20)","v":"Urnials"},{"$f":"'Data Capture Demand'!D20","v":1000},{"$f":"'Data Capture Demand'!G20","v":85},{"$f":"SUM(E15*'Data Capture Demand'!F20)","v":85000},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":72.627737226277375},72627.737226277372,0,0,72.627737226277375,72627.737226277372,null,-12.372262773722625,-12372.262773722628]
[null,null,{"$f":"IF('Data Capture Demand'!C21=\"\",\"\",'Data Capture Demand'!C21)","v":"Type 3"},{"$f":"'Data Capture Demand'!D21","v":0},{"$f":"'Data Capture Demand'!G21","v":0},{"$f":"SUM(E16*'Data Capture Demand'!F21)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":72.627737226277375},0,0,0,72.627737226277375,0,null,72.627737226277375,0]
[null,null,{"$f":"IF('Data Capture Demand'!C22=\"\",\"\",'Data Capture Demand'!C22)","v":"Type 4"},{"$f":"'Data Capture Demand'!D22","v":0},{"$f":"'Data Capture Demand'!G22","v":0},{"$f":"SUM(E17*'Data Capture Demand'!F22)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":72.627737226277375},0,0,0,72.627737226277375,0,null,72.627737226277375,0]
[null,null,{"$f":"IF('Data Capture Demand'!C23=\"\",\"\",'Data Capture Demand'!C23)","v":"Type 5"},{"$f":"'Data Capture Demand'!D23","v":0},{"$f":"'Data Capture Demand'!G23","v":0},{"$f":"SUM(E18*'Data Capture Demand'!F23)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":72.627737226277375},0,0,0,72.627737226277375,0,null,72.627737226277375,0]
[null,null,{"$f":"IF('Data Capture Demand'!C24=\"\",\"\",'Data Capture Demand'!C24)","v":"Type 6"},{"$f":"'Data Capture Demand'!D24","v":0},{"$f":"'Data Capture Demand'!G24","v":0},{"$f":"SUM(E19*'Data Capture Demand'!F24)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":72.627737226277375},0,0,0,72.627737226277375,0,null,72.627737226277375,0]
[null,null,{"$f":"IF('Data Capture Demand'!C25=\"\",\"\",'Data Capture Demand'!C25)","v":"Type 7"},{"$f":"'Data Capture Demand'!D25","v":0},{"$f":"'Data Capture Demand'!G25","v":0},{"$f":"SUM(E20*'Data Capture Demand'!F25)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":72.627737226277375},0,0,0,72.627737226277375,0,null,72.627737226277375,0]
[null,null,{"$f":"IF('Data Capture Demand'!C26=\"\",\"\",'Data Capture Demand'!C26)","v":"Type 8"},{"$f":"'Data Capture Demand'!D26","v":0},{"$f":"'Data Capture Demand'!G26","v":0},{"$f":"SUM(E21*'Data Capture Demand'!F26)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":72.627737226277375},0,0,0,72.627737226277375,0,null,72.627737226277375,0]
[null,null,{"$f":"IF('Data Capture Demand'!C27=\"\",\"\",'Data Capture Demand'!C27)","v":"Type 9"},{"$f":"'Data Capture Demand'!D27","v":0},{"$f":"'Data Capture Demand'!G27","v":0},{"$f":"SUM(E22*'Data Capture Demand'!F27)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":72.627737226277375},0,0,0,72.627737226277375,0,null,72.627737226277375,0]
[null,null,{"$f":"'Data Capture Demand'!C18&\" TOTAL\"","v":"INDUSTRIAL TOTAL"},{"$f":"SUM(D14:D22)","v":2000},null,{"$f":"SUM(F14:F22)","v":170000},null,{"$f":"SUM(H14:H22)","v":145255.47445255474},null,null,null,{"$f":"SUM(L14:L22)","v":145255.47445255474},null,null,{"$f":"SUM(O14:O22)","v":-24744.525547445257}]
[null,null,{"$f":"IF('Data Capture Demand'!C31=\"\",\"\",'Data Capture Demand'!C31)","v":"Per Toilet Pan"},{"$f":"'Data Capture Demand'!D31","v":500},{"$f":"'Data Capture Demand'!G31","v":85},{"$f":"SUM(E24*'Data Capture Demand'!F31)","v":34000},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":72.627737226277375},{"$f":"SUM(D24*G24)","v":36313.868613138686},0,0,{"$f":"SUM(G24*J24%)+G24","v":72.627737226277375},{"$f":"D24*K24","v":36313.868613138686},null,{"$f":"K24-E24","v":-12.372262773722625},2313.8686131386858]
[null,null,{"$f":"IF('Data Capture Demand'!C32=\"\",\"\",'Data Capture Demand'!C32)","v":"Per Urinal"},{"$f":"'Data Capture Demand'!D32","v":500},{"$f":"'Data Capture Demand'!G32","v":0},{"$f":"SUM(E25*'Data Capture Demand'!F32)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":72.627737226277375},{"$f":"SUM(D25*G25)","v":36313.868613138686},0,0,{"$f":"SUM(G25*J25%)+G25","v":72.627737226277375},{"$f":"D25*K25","v":36313.868613138686},null,72.627737226277375,36313.868613138686]
[null,null,{"$f":"IF('Data Capture Demand'!C33=\"\",\"\",'Data Capture Demand'!C33)","v":"Type 3"},{"$f":"'Data Capture Demand'!D33","v":0},{"$f":"'Data Capture Demand'!G33","v":0},{"$f":"SUM(E26*'Data Capture Demand'!F33)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":72.627737226277375},{"$f":"SUM(D26*G26)","v":0},0,0,{"$f":"SUM(G26*J26%)+G26","v":72.627737226277375},{"$f":"D26*K26","v":0},null,72.627737226277375,0]
[null,null,{"$f":"IF('Data Capture Demand'!C34=\"\",\"\",'Data Capture Demand'!C34)","v":"Type 4"},{"$f":"'Data Capture Demand'!D34","v":0},{"$f":"'Data Capture Demand'!G34","v":0},{"$f":"SUM(E27*'Data Capture Demand'!F34)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":72.627737226277375},{"$f":"SUM(D27*G27)","v":0},0,0,{"$f":"SUM(G27*J27%)+G27","v":72.627737226277375},{"$f":"D27*K27","v":0},null,72.627737226277375,0]
[null,null,{"$f":"IF('Data Capture Demand'!C35=\"\",\"\",'Data Capture Demand'!C35)","v":"Type 5"},{"$f":"'Data Capture Demand'!D35","v":0},{"$f":"'Data Capture Demand'!G35","v":0},{"$f":"SUM(E28*'Data Capture Demand'!F35)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":72.627737226277375},{"$f":"SUM(D28*G28)","v":0},0,0,{"$f":"SUM(G28*J28%)+G28","v":72.627737226277375},{"$f":"D28*K28","v":0},null,72.627737226277375,0]
[null,null,{"$f":"'Data Capture Demand'!C30&\" TOTAL\"","v":"COMMERCIAL TOTAL"},{"$f":"SUM(D24:D28)","v":1000},null,{"$f":"SUM(F24:F28)","v":34000},null,{"$f":"SUM(H24:H28)","v":72627.737226277372},null,null,null,{"$f":"SUM(L24:L28)","v":72627.737226277372},null,null,{"$f":"SUM(O24:O28)","v":38627.737226277372}]
[null,null,{"$f":"IF('Data Capture Demand'!C39=\"\",\"\",'Data Capture Demand'!C39)","v":"Municipal - toilets"},{"$f":"'Data Capture Demand'!D39","v":250},{"$f":"'Data Capture Demand'!G39","v":60},{"$f":"SUM(E30*'Data Capture Demand'!F39)","v":15000},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":72.627737226277375},{"$f":"SUM(D30*G30)","v":18156.934306569343},0,0,{"$f":"SUM(G30*J30%)+G30","v":72.627737226277375},{"$f":"D30*K30","v":18156.934306569343},null,{"$f":"K30-E30","v":12.627737226277375},{"$f":"L30-F30","v":3156.9343065693429}]
[null,null,{"$f":"IF('Data Capture Demand'!C40=\"\",\"\",'Data Capture Demand'!C40)","v":"Municipal - Urinals"},{"$f":"'Data Capture Demand'!D40","v":250},{"$f":"'Data Capture Demand'!G40","v":60},{"$f":"SUM(E31*'Data Capture Demand'!F40)","v":15000},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":72.627737226277375},18156.934306569343,0,0,72.627737226277375,18156.934306569343,null,12.627737226277375,3156.9343065693429]
[null,null,{"$f":"IF('Data Capture Demand'!C41=\"\",\"\",'Data Capture Demand'!C41)","v":"Bona Fide Sports Clubs"},{"$f":"'Data Capture Demand'!D41","v":0},{"$f":"'Data Capture Demand'!G41","v":0},{"$f":"SUM(E32*'Data Capture Demand'!F41)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":72.627737226277375},0,0,0,72.627737226277375,0,null,72.627737226277375,0]
[null,null,{"$f":"IF('Data Capture Demand'!C42=\"\",\"\",'Data Capture Demand'!C42)","v":"Other"},{"$f":"'Data Capture Demand'!D42","v":0},{"$f":"'Data Capture Demand'!G42","v":0},{"$f":"SUM(E33*'Data Capture Demand'!F42)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":72.627737226277375},0,0,0,72.627737226277375,0,null,72.627737226277375,0]
[null,null,{"$f":"IF('Data Capture Demand'!C43=\"\",\"\",'Data Capture Demand'!C43)","v":"Other"},{"$f":"'Data Capture Demand'!D43","v":0},{"$f":"'Data Capture Demand'!G43","v":0},{"$f":"SUM(E34*'Data Capture Demand'!F43)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":72.627737226277375},0,0,0,72.627737226277375,0,null,72.627737226277375,0]
[null,null,{"$f":"IF('Data Capture Demand'!C44=\"\",\"\",'Data Capture Demand'!C44)","v":"Other"},{"$f":"'Data Capture Demand'!D44","v":0},{"$f":"'Data Capture Demand'!G44","v":0},{"$f":"SUM(E35*'Data Capture Demand'!F44)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":72.627737226277375},0,0,0,72.627737226277375,0,null,72.627737226277375,0]
[null,null,{"$f":"IF('Data Capture Demand'!C45=\"\",\"\",'Data Capture Demand'!C45)","v":"Other"},{"$f":"'Data Capture Demand'!D45","v":0},{"$f":"'Data Capture Demand'!G45","v":0},{"$f":"SUM(E36*'Data Capture Demand'!F45)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":72.627737226277375},0,0,0,72.627737226277375,0,null,72.627737226277375,0]
[null,null,{"$f":"IF('Data Capture Demand'!C46=\"\",\"\",'Data Capture Demand'!C46)","v":"Other"},{"$f":"'Data Capture Demand'!D46","v":0},{"$f":"'Data Capture Demand'!G46","v":0},{"$f":"SUM(E37*'Data Capture Demand'!F46)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":72.627737226277375},0,0,0,72.627737226277375,0,null,72.627737226277375,0]
[null,null,{"$f":"IF('Data Capture Demand'!C47=\"\",\"\",'Data Capture Demand'!C47)","v":"Other"},{"$f":"'Data Capture Demand'!D47","v":0},{"$f":"'Data Capture Demand'!G47","v":0},{"$f":"SUM(E38*'Data Capture Demand'!F47)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":72.627737226277375},0,0,0,72.627737226277375,0,null,72.627737226277375,0]
[null,null,{"$f":"IF('Data Capture Demand'!C48=\"\",\"\",'Data Capture Demand'!C48)","v":"Other"},{"$f":"'Data Capture Demand'!D48","v":0},{"$f":"'Data Capture Demand'!G48","v":0},{"$f":"SUM(E39*'Data Capture Demand'!F48)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":72.627737226277375},0,0,0,72.627737226277375,0,null,72.627737226277375,0]
[null,null,{"$f":"'Data Capture Demand'!C38&\" TOTAL\"","v":"INSTITUTIONAL TOTAL"},{"$f":"SUM(D30:D39)","v":500},null,{"$f":"SUM(F30:F39)","v":30000},null,{"$f":"SUM(H30:H39)","v":36313.868613138686},null,null,null,{"$f":"SUM(L30:L39)","v":36313.868613138686},null,null,{"$f":"SUM(O30:O39)","v":6313.8686131386858}]
[]
[null,null,"SUBTOTAL",{"$f":"SUM(D40+D29+D23+D13)","v":13700},null,{"$f":"SUM(F40+F29+F23+F13)","v":1092500},null,{"$f":"SUM(H40+H29+H23+H13)","v":995000},null,null,null,{"$f":"SUM(L40+L29+L23+L13)","v":995000},null,null,{"$f":"SUM(O40+O29+O23+O13)","v":-97500}]
[]
[null,null,"FULL COST",{"$f":"'Data Capture Costs'!E31","v":995000},"CURRENT ACTUAL",null,null,null,null,null,"ANTICIPATED"]
[null,null,null,null,"MONTHLY",null,"ANNUALLY",null,null,null,"MONTHLY",null,"ANNUALLY"]
[null,null,null,null,"Current Revenue",{"$f":"F42","v":1092500},{"$f":"F46*12","v":13110000},null,null,null,"Revised Revenue",{"$f":"L42","v":995000},{"$f":"L46*12","v":11940000}]
[null,null,null,null,"PROFIT\\LOSS",{"$f":"F46-D44","v":97500},{"$f":"F47*12","v":1170000},null,null,null,"PROFIT\\LOSS",{"$f":"L46-D44","v":0},{"$f":"L47*12","v":0}]